UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BZpz1yUWDBfPaj7rCuTcpHZCsTpVHDFegmEkJWfMEi4='
WHERE
key_id = '6adb39067e7fc9d854287a3044a6de8ff7ccfc4f708124ac83d14256019b9404'
AND (
token = 'BZpz1yUWDBfPaj7rCuTcpHZCsTpVHDFegmEkJWfMEi4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)