UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6f4FfK9z3oG5UJwhEj8EJEYJRpEEH+knJdxMWh2K4c='
WHERE
key_id = '555c82c103850ca1a579cf797993368e0b524016534b3d1598c3988e56889b57'
AND (
token = 'D6f4FfK9z3oG5UJwhEj8EJEYJRpEEH+knJdxMWh2K4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)