UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xtnHfMJcAmLVNKeFgIr7gmxMi1xfMVhka4GZJIheQ8='
WHERE
key_id = 'e0421b405142b669c2f6e9642ef589134e73945a75d20cf822da4cc0f66a7c4e'
AND (
token = '0xtnHfMJcAmLVNKeFgIr7gmxMi1xfMVhka4GZJIheQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)