UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '42BiiG7y2MAwaTiFjMpdRZNWplrPeQzuFD7601UPYzs='
WHERE
key_id = '1ad483d1aaf02a27c63ff67406bf7b7af1507b047fd76a31565522186823a1bd'
AND (
token = '42BiiG7y2MAwaTiFjMpdRZNWplrPeQzuFD7601UPYzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)