UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pUGJukoT35N33dhxdeFB53wipJP0tX2XGwc4zyWfAlA='
WHERE
key_id = 'ad5a4effb454c0fdaca31a49f3acbfbafbd9a0193a143d43615229a2ff5ef54d'
AND (
token = 'pUGJukoT35N33dhxdeFB53wipJP0tX2XGwc4zyWfAlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)