UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l1lKIugb4uYd+d/jDg+RTLrT8DXRUm8zmeG/BSUySOY='
WHERE
key_id = 'bcd528a1a0916e38a1ce8ac3156ce70f43605365ca7ffae890a20cbeb4a68fc7'
AND (
token = 'l1lKIugb4uYd+d/jDg+RTLrT8DXRUm8zmeG/BSUySOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)