UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27jPWssxJB/Rw9wFzs9uZznCq+PAbA9Bm77gkyihuLc='
WHERE
key_id = '11c8687253c4542dd8b645a634ff2bddc702800a3fd0a3b0a3dc93bfebb77723'
AND (
token = '27jPWssxJB/Rw9wFzs9uZznCq+PAbA9Bm77gkyihuLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)