UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2jE/kEMOZDXZJ24P+K6XBogjwvEYDbC8RmE1yK3g0ss='
WHERE
key_id = 'e0f2352e2c50573caf1b1a00168c7d1b049a61f8911ad3df6d70907b9f6fbeac'
AND (
token = '2jE/kEMOZDXZJ24P+K6XBogjwvEYDbC8RmE1yK3g0ss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)