UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aKicLDoMZrnUHNJC9Ae3cDD5Gg2fvKQ6Wm4YPgeafOs='
WHERE
key_id = '6993d29dc198fa7d74ae38166a1f66c2e6876764fbe75a2dc554d692e6cbda6f'
AND (
token = 'aKicLDoMZrnUHNJC9Ae3cDD5Gg2fvKQ6Wm4YPgeafOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)