UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+aw0iNs5D0jBykYQTIxksx+6TqRlqI8FDYDTASsPEC8='
WHERE
key_id = 'a9aa9c8cc84b6d1fe97eeab905161c2379a806e9c4c345dbabe87a9f6bb16fa3'
AND (
token = '+aw0iNs5D0jBykYQTIxksx+6TqRlqI8FDYDTASsPEC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)