UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x6KtAtnkwy3wi3YKYF3i9hDjF0TbGV4VV6+I1/kWRP4='
WHERE
key_id = 'dd491044be6f9dc546a6837cc76fdf1b7c58ed4dacb9c174270c120d1249d2ee'
AND (
token = 'x6KtAtnkwy3wi3YKYF3i9hDjF0TbGV4VV6+I1/kWRP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)