UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZjdmsoqqRfHJh5soc1rVd2yDI1omKN71V330MYk/RSo='
WHERE
key_id = '79da70fd6a32beb07d96b30c7034b3f0add41ac8f07050bcebc6c28a29717599'
AND (
token = 'ZjdmsoqqRfHJh5soc1rVd2yDI1omKN71V330MYk/RSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)