UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DR8cUI/TsIs1kUAb5koIQz2hlDN5cg78I+884SvHprc='
WHERE
key_id = '1800801df3c65bcabb1c8c6da8e4b9eb4a820c77c344f7602727b02635d7d1f4'
AND (
token = 'DR8cUI/TsIs1kUAb5koIQz2hlDN5cg78I+884SvHprc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)