UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GJkggY2zwucwUqaYUGMIXANviF/+BS1ShVzNEteolp8='
WHERE
key_id = 'b10be8c3dfe5f419dacdd6eb65ee481577851ffa8a5b6e3edb85f4c852a8a144'
AND (
token = 'GJkggY2zwucwUqaYUGMIXANviF/+BS1ShVzNEteolp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)