UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+dqBIUquwZ7bSaVnYSXbn0rsQuLUcjGANRT2PjSlyL8='
WHERE
key_id = '9bbad1c6f80becc564236d8344f35b1714118b062f2e93bcc65b4aa0bf5c2943'
AND (
token = '+dqBIUquwZ7bSaVnYSXbn0rsQuLUcjGANRT2PjSlyL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)