UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8bX9QEfKPnFg00P0KIem5DjXuS+EKSZGKmNYhDyk6ww='
WHERE
key_id = '65e4a9139276ffa2678604272a70607757674e8927aa40c1912b0bf0ce1c0c4b'
AND (
token = '8bX9QEfKPnFg00P0KIem5DjXuS+EKSZGKmNYhDyk6ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)