UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L7aKHtir2it3fl89FdYF05A0fWo+U6PRcf21c0PlEfc='
WHERE
key_id = '0547b93ff187d831868dc216df91e179bdea1d3d2bd48ae7031bdfac30c023a9'
AND (
token = 'L7aKHtir2it3fl89FdYF05A0fWo+U6PRcf21c0PlEfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)