UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pn2ASM6iok4CiDwOvNlVxcaBzIOWY8wEEHJ/k6kWYrg='
WHERE
key_id = 'a6bb865e99f26c012947272e2ec6c0552a302ea6cb1326ff422dc73e74a7c6fa'
AND (
token = 'Pn2ASM6iok4CiDwOvNlVxcaBzIOWY8wEEHJ/k6kWYrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)