UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c2+HS3+/cWNCOsDeNzR0XQlRCr02vf5upACQ47KSjPY='
WHERE
key_id = '031a469eb3cdbe313c6dd14d407f414056893ff9e8fc414df3cff18d37dddacd'
AND (
token = 'c2+HS3+/cWNCOsDeNzR0XQlRCr02vf5upACQ47KSjPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)