UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mHfwZCiYJSBkLeAyO9jBEp2ai3wlCehxx8awFl2qhv0='
WHERE
key_id = 'f8f112c2b4e01a69dd4af285c279ae3bd6f35410e4eb912d49c8dcca44a383aa'
AND (
token = 'mHfwZCiYJSBkLeAyO9jBEp2ai3wlCehxx8awFl2qhv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)