UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pJ2KHFl+PXuFadtWdj5MpnG2zfOaoKZILXXqna40kOM='
WHERE
key_id = '0bfe67123e0d9ff59fb9bfd5f6ec1f565ddf17cfff74cc2479271551e2d86e7b'
AND (
token = 'pJ2KHFl+PXuFadtWdj5MpnG2zfOaoKZILXXqna40kOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)