UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/9yI0X5dF5iD9VQIx801DCAmhNMsrz+sSHf+21iR+YM='
WHERE
key_id = 'd67141f1db74ca8fe706a5f08fd8ffde7d33cb75502a9e517c2a811c76d116f9'
AND (
token = '/9yI0X5dF5iD9VQIx801DCAmhNMsrz+sSHf+21iR+YM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)