UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZnG8tJS+jwa7KNpK6hocz5ckz9Po8A497VQ2UKhifg='
WHERE
key_id = 'ae01e822d7354061f64e17fa37ce28b2deda86aff6c5d07869d3fd720f8d76df'
AND (
token = '0ZnG8tJS+jwa7KNpK6hocz5ckz9Po8A497VQ2UKhifg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)