UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OZW97hvkbmaeZDWXffXHH84dqH1aPtRpnynHb4I/1yI='
WHERE
key_id = '4c987ba49aa4b223b192eb84558f30fe8319a2ec339e206b29ce889b9d68f249'
AND (
token = 'OZW97hvkbmaeZDWXffXHH84dqH1aPtRpnynHb4I/1yI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)