UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Z0ubMYPZOWrcapBvx1pBADPgpRnk0aVXm4L+/2kqQ8='
WHERE
key_id = '57a8d03b6400a76d6b042df4235e055bac8b9ba18a0cb9c18f2f6399a1890dd8'
AND (
token = '+Z0ubMYPZOWrcapBvx1pBADPgpRnk0aVXm4L+/2kqQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)