UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6RGH85C8nkmE/D/XGj4WX3yyzJYh41PK/2P+VmB29N8='
WHERE
key_id = 'df5be4b9cb49d1a0f7e80aaef523cf1b00f149ecf0a503e76bf4370a077088be'
AND (
token = '6RGH85C8nkmE/D/XGj4WX3yyzJYh41PK/2P+VmB29N8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)