UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9SJI6Wme0dgRLGjrptxX/qRoEtA1SXW0uIkcshWV/s='
WHERE
key_id = '02c57b073938d876eaee336a73f32cbbd7bcafa5e8ebe7b3d703e0ae8e31ee5b'
AND (
token = 'S9SJI6Wme0dgRLGjrptxX/qRoEtA1SXW0uIkcshWV/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)