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