UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ETxdMRi0FjDjolk2VB6NsVzFeYUiXi4WAlsc8BjzcA8='
WHERE
key_id = '99d2cc32af4edb65bacb6d2abb2d3eadb1eff3fbf56b02ace4306a7fb9f6a1e9'
AND (
token = 'ETxdMRi0FjDjolk2VB6NsVzFeYUiXi4WAlsc8BjzcA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)