UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i8I9kGqLZs70udI19PmKWduLxTjuvoKfhPoJfNx/phk='
WHERE
key_id = '65397f2515b691f739d02925cab40c8d624fa8ed317668e209d3246a9c0fa314'
AND (
token = 'i8I9kGqLZs70udI19PmKWduLxTjuvoKfhPoJfNx/phk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)