UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BpATS3Guw63sWgSP5nfYPZ4/7sPEHYydt1p36aPpP+k='
WHERE
key_id = 'b3d2c4c681dad50f69ddebd8fd291d8c9cd0d8ff7295f715cb06bd09427470f1'
AND (
token = 'BpATS3Guw63sWgSP5nfYPZ4/7sPEHYydt1p36aPpP+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)