UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgIZlR0YSXzbFhbjFAsfaQGgFb5w+pfJuWkzoPCkiWk='
WHERE
key_id = 'ea7fcb3ff19f9a06c17be91033e6377aa1853861934e7dffb1a0c102a9b361c1'
AND (
token = 'sgIZlR0YSXzbFhbjFAsfaQGgFb5w+pfJuWkzoPCkiWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)