UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nh9abYVxGvI2asXfW0Ahw2ulZai2UB8HwYFZ0kXV6yo='
WHERE
key_id = '4eae89958cc024bf23d72518761f51e57f925c3a9269abc1c04170445666dccc'
AND (
token = 'Nh9abYVxGvI2asXfW0Ahw2ulZai2UB8HwYFZ0kXV6yo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)